SORT AGGREGATE
Short Description
Retrieval of a single row after applying a group function to a set of selected rows. In this case, the database “sorts” a single row.
Detailed Description
This is not so much a SORTing step rather than an AGGREGATION one. A single row will be passed on to the next execution step.
Further Reading
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.